<!DOCTYPE html>
<html lang="en">
<head>
	<meta charset="UTF-8">
	<meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
	<title>Frozen Indices | ElasticSearch 7.7 权威指南中文版</title>
	<meta name="keywords" content="ElasticSearch 权威指南中文版, elasticsearch 7, es7, 实时数据分析，实时数据检索" />
    <meta name="description" content="ElasticSearch 权威指南中文版, elasticsearch 7, es7, 实时数据分析，实时数据检索" />
    <!-- Give IE8 a fighting chance -->
    <!--[if lt IE 9]>
    <script src="https://oss.maxcdn.com/html5shiv/3.7.2/html5shiv.min.js"></script>
    <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
    <![endif]-->
	<link rel="stylesheet" type="text/css" href="../static/styles.css" />
	<script>
	var _link = 'sql-index-frozen.html';
    </script>
</head>
<body>
<div class="main-container">
    <section id="content">
        <div class="content-wrapper">
            <section id="guide" lang="zh_cn">
                <div class="container">
                    <div class="row">
                        <div class="col-xs-12 col-sm-8 col-md-8 guide-section">
                            <div style="color:gray; word-break: break-all; font-size:12px;">原英文版地址: <a href="https://www.elastic.co/guide/en/elasticsearch/reference/7.7/sql-index-frozen.html" rel="nofollow" target="_blank">https://www.elastic.co/guide/en/elasticsearch/reference/7.7/sql-index-frozen.html</a>, 原文档版权归 www.elastic.co 所有<br/>本地英文版地址: <a href="../en/sql-index-frozen.html" rel="nofollow" target="_blank">../en/sql-index-frozen.html</a></div>
                        <!-- start body -->
                  <div class="page_header">
<strong>重要</strong>: 此版本不会发布额外的bug修复或文档更新。最新信息请参考 <a href="https://www.elastic.co/guide/en/elasticsearch/reference/current/index.html" rel="nofollow">当前版本文档</a>。
</div>
<div id="content">
<div class="breadcrumbs">
<span class="breadcrumb-link"><a href="index.html">Elasticsearch Guide [7.7]</a></span>
»
<span class="breadcrumb-link"><a href="xpack-sql.html">SQL access</a></span>
»
<span class="breadcrumb-link"><a href="sql-spec.html">SQL Language</a></span>
»
<span class="breadcrumb-node">Frozen Indices</span>
</div>
<div class="navheader">
<span class="prev">
<a href="sql-index-patterns.html">« Index patterns</a>
</span>
<span class="next">
<a href="sql-functions.html">Functions and Operators »</a>
</span>
</div>
<div class="section">
<div class="titlepage"><div><div>
<h2 class="title">
<a id="sql-index-frozen"></a>Frozen Indices<a class="edit_me edit_me_private" rel="nofollow" title="Editing on GitHub is available to Elastic" href="https://github.com/elastic/elasticsearch/edit/7.7/docs/reference/sql/language/indices.asciidoc">edit</a>
</h2>
</div></div></div>
<p>Elasticsearch <a class="xref" href="frozen-indices.html" title="Frozen indices">frozen indices</a> are a useful and powerful tool for hot/warm architecture introduced in Elasticsearch 6.6,
essentially by trading speed for memory.
Elasticsearch SQL supports frozen indices and similar to Elasticsearch, due to their performance characteristics, allows searches on them only
when explicitly told so by user - in other words, by default, frozen indices are not included in searches.</p>
<p>One can toggle the use of frozen indices through:</p>
<div class="variablelist">
<dl class="variablelist">
<dt>
<span class="term">
dedicated configuration parameter
</span>
</dt>
<dd>
Set to <code class="literal">true</code> properties <code class="literal">index_include_frozen</code> in the <a class="xref" href="sql-rest.html" title="SQL REST API"><em>SQL REST API</em></a> or <code class="literal">index.include.frozen</code> in the drivers to include frozen indices.
</dd>
<dt>
<span class="term">
dedicated keyword
</span>
</dt>
<dd>
Explicitly perform the inclusion through the dedicated <code class="literal">FROZEN</code> keyword in the <code class="literal">FROM</code> clause or <code class="literal">INCLUDE FROZEN</code> in the <code class="literal">SHOW</code> commands:
</dd>
</dl>
</div>
<div class="pre_wrapper lang-sql">
<pre class="programlisting prettyprint lang-sql">SHOW TABLES INCLUDE FROZEN;

     name      |     type      |     kind
---------------+---------------+---------------
archive        |BASE TABLE     |FROZEN INDEX
emp            |BASE TABLE     |INDEX
employees      |VIEW           |ALIAS
library        |BASE TABLE     |INDEX</pre>
</div>
<div class="pre_wrapper lang-sql">
<pre class="programlisting prettyprint lang-sql">SELECT * FROM FROZEN archive LIMIT 1;

     author      |        name        |  page_count   |    release_date
-----------------+--------------------+---------------+--------------------
James S.A. Corey |Leviathan Wakes     |561            |2011-06-02T00:00:00Z</pre>
</div>
<p>Unless enabled, frozen indices are completely ignored; it is as if they do not exist and as such, queries ran against them are likely to fail.</p>
</div>
<div class="navfooter">
<span class="prev">
<a href="sql-index-patterns.html">« Index patterns</a>
</span>
<span class="next">
<a href="sql-functions.html">Functions and Operators »</a>
</span>
</div>
</div>

                  <!-- end body -->
                        </div>
                        <div class="col-xs-12 col-sm-4 col-md-4" id="right_col">
                        
                        </div>
                    </div>
                </div>
            </section>
        </div>
    </section>
</div>
<script src="../static/cn.js"></script>
</body>
</html>